SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_GetFileLinkByNo] ( @JOL_File_No INT )
AS 
    SELECT  JOL_File_No,
            JOL_File_Title,
            JOL_File_Type,
            JOL_File_FileUrl,
            JOL_File_Remark,
            JOL_File_AddTime,
            JOL_File_AddUser,
            JOL_File_UpdateTime,
            JOL_File_UpdateUser
    FROM    dbo.JOL_FileLink
    WHERE   JOL_File_No = @JOL_File_No
GO
